#!/usr/bin/env python
# -*- coding:utf-8 -*-
# Author:Taotie Ren
# import logging 
# 禁用日志模块
# logging.disable(logging.CRITICAL)
# logging.basicConfig(level=logging.DEBUG, format=' %(asctime)s - %(levelname)s - %(message)s')

# removeCSVHeader.py - Removes the header from all CSV files in the current working directory.

import csv, os
os.makedirs('CSV', exist_ok=True)
os.makedirs('CSV\\headerRemoved', exist_ok=True)

# Loop through every file in the current working directory.
for csvFilename in os.listdir('CSV'):
	if not csvFilename.endswith('.csv'):
		continue        # skip non-csv files

	print('Removing header from ' + csvFilename + '...')

# Read the CSV file in skipping first row.
csvRows = []
csvFileObj = open(csvFilename)
readerObj = csv.reader(csvFileObj)
for row in readerObj:
	if readerObj.line_num == 1:
		continue        # skip first row
	csvRows.append(row)
csvFileObj.close()

# Write out the CSV file.
csvFileObj = open(os.path.join('CSV\\headerRemoved', csvFilename), 'w', newline=' ')
csvWriter = csv.writer(csvFileObj)
for row in csvRows:
	csvWriter.writer(row)
csvFileObj.close()
